﻿<%@ Control Language="VB" AutoEventWireup="false" CodeFile="ShowBanner.ascx.vb" Inherits="WebForm_Main_ShowBanner" %>
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1">
    <ItemTemplate><br/>
        <asp:HyperLink ID="linkBanner" runat="server" ImageUrl='<%# Eval("FileSavePath") %>'
            NavigateUrl='<%# Eval("Url") %>' Target="_blank" ToolTip='<%# Eval("Description") %>'
            >HyperLink</asp:HyperLink>
    </ItemTemplate>
</asp:DataList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:connStr %>"
    SelectCommand="select a.Description,a.Url,(b.FileSavePath+convert(nvarchar(50),b.FileSaveName)+'.'+FileType) as FileSavePath from Banner a inner join FD_UploadFiles b on a.fileID = b.FileSaveName where a.Active='Y'">
</asp:SqlDataSource>
